Release 10.1A: OpenEdge Data Management:
SQL Reference

DAYOFWEEK

Returns the day of the week in the argument as a short integer value in the range of 1–7.

The argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.

Syntax

DAYOFWEEK ( date_expression )

Example

The following example shows how to use the DAYOFWEEK function:

SELECT *     FROM orders     WHERE DAYOFWEEK (order_date) = 2 ;

Notes

The argument to the function must be of type DATE.
If date_expression is supplied as a date literal, it can be any of the valid date_literal formats where the day specification (DD) precedes the month specification (MM).
The result is of type SHORT.
If the argument expression evaluates to NULL, the result is NULL.

Compatibility

ODBC compatible